Mergecontentdbs gives a "Database Not Found" Error
Hi,
Trying to split our SP 2007 content DB's to smaller chunks and get the "Database Not Found error" I double checked the DB srver and the database exists as I created it and have full control over it. I ran te stsadm "enumcontentdbs"to
check the dbs and it exists but still get the error.
C:\>stsadm -o enumcontentdbs -url http://qm-unite.grouphc.net
<Databases Count="1">
<ContentDatabase Server="GRPSDHEID0003" Name="WSS_Content_Unite_QM" />
</Databases>
C:\>stsadm -o mergecontentdbs -url http://qm-unite.grouphc.net -sourcedatabasena
me WSS_Content_Unite_QM -destinationdatabasename WSS_Content_Team_QM -operation
1
Database not found.
C:\>
Any Suggestions?
Regards
SS
sabu
May 4th, 2011 2:37pm
Hello,
What method did you use to split them?
Thanks!
TomTom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award -
Linked-In - SharePoint Gypsy
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2011 3:16pm
Hi Sabu21s,
Please refer to the following two articles to see if your problem is similar with any of them, and then try the solutions there. Maybe this could help you to solve
this issue:
http://www.sharepoint-insight.com/2009/07/21/sharepoint-wss-3-0-sql-database-not-found-error/;
http://cs.grossmann.com/blogs/fg/archive/2007/07/08/sharepoint-wss-2-0-to-wss-3-0-moss-2007-experiences.aspx.
Thanks & Regards,
Peng Lei
May 5th, 2011 9:35pm
Hi Sabu21s,
Here's a good article on how to add, split and merge SP databases:
http://technet.microsoft.com/en-us/library/cc825326(office.12).aspx
Thanks!
Tom
Tom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award -
Linked-In - SharePoint Gypsy
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 8:21am
Here's a good article on how to add, split and merge SP databases:
I forgot to add it to a web app via CA... Here what I did...
1) First Add Db's to the web Apps in Central Admin
2) Command to Read from File:
C:\>stsadm -o mergecontentdbs -urlp://mysiteurl -sourcedatabasename WSS_Content_QM -destinationdatabasename WSS_Content_test_QM -operation 3 -filename D:\Merge\site.xml
3) After the Merge is done do the following:
Do an IIS Reset on all servers
Start the Full Crawl (Important)
sabu
May 6th, 2011 10:10am
Hi Sabu21s,
Here's a good article on how to add, split and merge SP databases:
http://technet.microsoft.com/en-us/library/cc825326(office.12).aspx
Thanks!
Tom
Tom Molskow - SharePoint Architect - Microsoft Community Contributor 2011 Award -
Linked-In - SharePoint Gypsy
I forgot to add it to a web app via CA... Here what I did...
1) First Add Db's to the web Apps in Central Admin
2) Command to Read from File:
C:\>stsadm -o mergecontentdbs -urlp://mysiteurl -sourcedatabasename WSS_Content_QM -destinationdatabasename WSS_Content_test_QM -operation 3 -filename D:\Merge\site.xml
3) After the Merge is done do the following:
Do an IIS Reset on all servers
Start the Full Crawl (Important)sabu
Free Windows Admin Tool Kit Click here and download it now
May 6th, 2011 10:11am